At Finance/Accounts payable/Payables/Date, you can generate a graph in Microsoft Excel that shows the sum of outstanding amount per date after the accounts payables have been processed. This graph is useful as it helps the management with decisions such as the amount needed to pay creditors at certain periods.
Note: The menu path differs according to the different legislations. For example, the menu path for Exact North America is Finance/Reports/Accounts payable/Date.
You can filter the data that you want to display. To search for the data, you can define one or more of the following criteria and click Start. The data that matches the search criteria you have entered is then displayed in graph form.
Type or select the creditor range or select the All check box to generate the graph for all creditors.
Type or select the classification range of the creditors or select the All check box to generate the graph for all classifications.
Select the Unprocessed check box to include entries that have yet to be processed.
Select the type of creditor to be generated in the graph. A creditor can be a supplier/vendor or an employee. Choose from Supplier, Payroll data (in case of employees), or All.
Select Invoice date, Due date or Reporting date as the reference date.
Click Start to generate the graph in Microsoft Excel.
Click the Graph, Table and Data tabs found at the bottom of the Microsoft Excel spreadsheet to browse through the information. The data can also be modified to meet your requirements. If you modify any data in the Table or Data tab, the graph in the Graph tab is updated automatically.
Click Close to exit.